package com.flyone.herbal.mapper;

import com.flyone.herbal.model.vo.TotalVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface AdminMapper {
    @Select("select count(*) from herbal.chinesemedicine")
    long getAllMedicines();

    @Select("select count(*) from herbal.user where isDelete=0")
    long getAllUsers();

    @Select("select count(*) from herbal.post where isDelete=0")
    long getAllPosts();

    @Select("select count(*) from herbal.中药方剂")
    long getAllPrescriptions();
}
